Mega Code Archive - Oracle PLSQL Tutorial

Trigger
1) A row-level trigger
2) A trigger is an event within the DBMS that can cause some code to execute automatically
3) A trigger prevents updates after business hours
4) AFTER CREATE ON SCHEMA
5) AFTER DDL ON SCHEMA
6) After delete trigger
7) AFTER INSERT OR UPDATE ON tableName
8) After insert trigger
9) AFTER SUSPEND ON SCHEMA
10) After update trigger
11) Alter trigger to disable it or enable it
12) An after statement level trigger and an after row level trigger
13) Audit trigger
14) Autonomous triggers
15) BEFORE EVENT triggers, are for preventing the event from actually happening
16) BEFORE INSERT OR UPDATE OF id
17) Building INSTEAD OF trigger views
18) Call PRAGMA AUTONOMOUS_TRANSACTION procedure
19) Call raise_application_error to report an error in a trigger
20) Change data in a before insert or update trigger
21) Change value in Row level trigger
22) Check and change new value in a before-insert trigger
23) Check new value in before insert trigger
24) Check new value in before trigger
25) Check the status of the trigger
26) Commit in trigger
27) Convert character values to upper case
28) Create instead of insert trigger on view
29) Create instead of update trigger on view
30) Creating a Trigger
31) Database level trigger
32) Database logoff trigger
33) Database logon trigger
34) Disable a trigger
35) DML Trigger Example
36) Dropping a Trigger
37) Enable a trigger
38) Enable and disable triggers
39) Fire a trigger before an update of the table
40) Firing a Trigger
41) FOR EACH ROW clause identifies this as a row-level trigger
42) For each row when condition
43) If ( updating or deleting ), if ( inserting or updating )
44) If new value is null use the value from a sequence
45) If trigger exists, drop trigger
46) If updating and new value equals old value
47) Implementing Autonumbering Functionality
48) Insert before trigger
49) INSERTING, DELETING and UPDATING Predicates
50) INSTEAD OF triggers
51) Is a Deleting action or an updating action
52) Is updating a certain column
53) IS_DROP_COLUMN
54) Logging All Operatins Using Autonumbering
55) Logging All Operations
56) Logging INSERT Operations
57) Logging INSERT Operations With WHEN Conditions
58) Mark trigger with PRAGMA AUTONOMOUS_TRANSACTION
59) New Database triggers
60) Old and new value
61) ORA_DICT_OBJ_TYPE, ORA_DICT_OBJ_OWNER, ORA_DICT_OBJ_NAME
62) ORA-01733
63) Output new and old value in a before update trigger
64) Placing triggers on tables
65) Raise application error in a trigger in case of invalid new value
66) Raise Exception from trigger
67) React to Inserting and Updating actions
68) Records a error in the error logging table
69) Reference current user name in trigger
70) Reference new value with
71) REFERENCING OLD AS old NEW AS new
72) REFERENCING OLD AS old_values NEW AS new_values
73) Refernece an old value in
74) Save information about all errors in an after-servererror on database
75) Schema trigger
76) SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
77) Show errors for a trigger
78) Solution for the Mutating Tables Problem
79) System triggers
80) The use of a trigger
81) Transaction with pragma autonomous_transaction
82) Trigger
83) Trigger Blocks
84) Trigger for auditing
85) Trigger for certain columns
86) Trigger on a view
87) Trigger on a view with user-defined types
88) Trigger that logs actions for inserting actions
89) Trigger that output old value
90) Trigger Which Modifies a Mutating Table
91) Trigger with a REFERENCING clause
92) Trigger with multiple triggering events
93) Trigger with REFERENCING and WHEN clauses
94) Triggers
95) Use audit table in a trigger
96) Use cursor in trigger
97) Use event attributes to provide more info
98) Use trigger to create autoincrement column
99) Use trigger to keep data consistency
100) Using an AFTER EVENT Trigger
101) Using the UPDATING (column_name) clause